﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'PRC_TB_USER_ADITIONAL_DAYS_SE')
	BEGIN
		DROP  Procedure  dbo.PRC_TB_USER_ADITIONAL_DAYS_SE
	END

GO

CREATE PROCEDURE [dbo].[PRC_TB_USER_ADITIONAL_DAYS_SE] 
(
    @TUADUSERID Integer )
AS
	SELECT a.TUAD_USER_ID, a.TUAD_DATE
	    FROM TB_USER_ADITIONAL_DAYS a
        where a.TUAD_USER_ID = @TUADUSERID
        ORDER BY a.TUAD_DATE


GO

GRANT EXEC ON dbo.PRC_TB_USER_ADITIONAL_DAYS_SE TO PUBLIC

GO

